package com.zlx.xbhy.mapper.provider;

import org.springframework.util.StringUtils;

/**
 * @ClassName MeetingSqlProvider
 * @Description TODO
 * @Author Edward
 * @Date 2020/11/22 16:06
 */
public class MeetingSqlProvider {
    public String seletePage(String title,Integer status){
        StringBuilder sb = new StringBuilder();
        sb.append("SELECT * FROM meeting WHERE title LIKE CONCAT('%',#{title},'%') ");
        if (!StringUtils.isEmpty(status)){
            sb.append("AND `status`=#{status}");
        }
        return sb.toString();
    }
}
